<%@ LANGUAGE="VBSCRIPT" %>
<%' option explicit%>
<% Response.Expires=0 %>
<%
dim aa, bb
aa=Request.ServerVariables("LOGON_USER")
bb=Request.Querystring("AN")
'if instr(1,aa, bb,1)=0 THEN
'response.clear
'response.end
'end if

aa=Request.ServerVariables("HTTP_USER_AGENT")
bb="Indy"
'if instr(1,aa, bb,1)=0 THEN
'response.clear
'response.end
'end if
%>
<!--METADATA NAME="Microsoft ActiveX Data Objects 2.5 Library" TYPE="TypeLib" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"-->
<%

dim Node,   DTA, AN
Node=request("Node")
if isEmpty(Node) then Node="_P"
DTA=request("DTA")
if isEmpty(DTA) then DTA=""
AN=request("AN")
if isEmpty(AN) then AN="0"
	Dim cnn
	Dim connStr
	dim cmd
	Set cnn=Server.CreateObject("ADODB.Connection")
    Set cmd=Server.CreateObject("ADODB.Command")
%>
<!-- #INCLUDE FILE="Connection.inc" -->
<%
''''	connStr="Provider=SQLOLEDB.1;Persist Security Info=True;User ID=Test;Password=Test;Initial Catalog=SMS"&Node&";Data Source=EM-HOME"
	cnn.open connStr
	Set cmd.ActiveConnection = cnn
	cmd.CommandType=adCmdStoredProc
	cmd.CommandText = "sp_AutomatLoading"

	Cmd.Parameters.Append Cmd.CreateParameter("@AutomatNumber", adVarChar, adParamInput,24)
	Cmd.Parameters.Append Cmd.CreateParameter("@Code", adVarChar, adParamInput,10)
	Cmd.Parameters.Append Cmd.CreateParameter("@DTA", adVarChar, adParamInput,20)
	Cmd.Parameters.Append Cmd.CreateParameter("@Res", adInteger, adParamOutput)
	Cmd("@AutomatNumber")=Request.Querystring("AN")
	Cmd("@Code")="Load2 / "&Request.querystring("Code")
	Cmd("@DTA")=DTA
	cmd.execute
	set cmd=nothing
	cnn.close
	set cnn=nothing

	''====================================================================================

''''if (AN="10")  OR (AN="8") OR (AN="qq")  THEN 
	server.execute("/automat/loadfiles/a22a.asp")
	response.end
''''end if
%>
OK

